You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
NASSARIUS DORSATUS |
6.00 | |
LYNCINA LYNX VANELLI |
12.00 | |
CYMBIOLA AULICA |
40.00 | |
TUTUFA OYAMAI |
12.00 | |
CONUS MOLUCCENSIS |
45.00 | |
ANODONTIA EDENTULA |
8.00 | |
LYNCINA LYNX VANELLI |
4.00 | |
MACOMA RHOMBOIDES |
4.00 | |
CONUS ROBINI |
6.00 | |
TELLINA ROSTRATA |
6.00 | |
DIVARICELLA CHAVANI |
8.00 | |
NOTADUSTA RABAULENSIS |
60.00 | |
STRICTISPIRA PAXILLUS |
5.00 | |
CORCULUM CARDISSA ROSEUM |
6.00 | |
CONUS SALMIAE |
40.00 | |
PECTEN ZICZAC |
8.00 | |
STRUTHIOLARIA PAPULOSA |
20.00 | |
MONOPLEX GEMMATUS |
4.00 | |
SEPTA VESPACEUM |
10.00 | |
LYNCINA LYNX VANELLI |
12.00 | |
GLYPHOSTOMA OTOHIMAE |
8.00 | |
SEPTA VESPACEUM |
6.00 | |
CONUS SANTINII |
380.00 | |
CASMARIA ERINACEUS VIBEX |
6.00 | |
STRUTHIOLARIA PAPULOSA |
20.00 | |
EROSARIA HELVOLA ARGELLA |
6.00 | |
CONUS WENDROSI |
8.00 | |
NASSARIUS EUGLYPTUS |
6.00 | |
NARIA LAMARCKII REDIMITA |
25.00 | |
Total: | 781.00 |